package com.tang.excel.batch.export;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Author: tang
 * @Description:
 * @Date 2025/1/2 15:02
 */
public interface PandaMapper {

    @Select("select * from panda")
    public List<Panda> selectAll();

    @Select("select * from panda t1 join (select id from panda limit #{offset,jdbcType=INTEGER},#{pageSize,jdbcType=INTEGER}) t2 on t1.id = t2.id")
    public List<Panda> selectPage(@Param("offset") Integer offset,@Param("pageSize") Integer pageSize);

    @Select("select count(*) from panda")
    public Integer selectCount();


}
